/*
MySQL Backup
Database: ai
Backup Time: 2023-09-20 04:12:32
*/

SET FOREIGN_KEY_CHECKS=0;
DROP TABLE IF EXISTS `ai`.`test1`;
DROP TABLE IF EXISTS `ai`.`userinfo`;
CREATE TABLE `test1` (
  `nam` varchar(5) NOT NULL,
  `num` int NOT NULL,
  PRIMARY KEY (`num`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
CREATE TABLE `userinfo` (
  `id` int NOT NULL AUTO_INCREMENT,
  `username` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '用户名\r\n',
  `Account` varchar(18) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '账号',
  `paswrod` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '密码\r\n',
  `creatTime` datetime DEFAULT NULL COMMENT '注册时间',
  `status` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci COMMENT '状态:1:正常 3:冻结 4:封号',
  `token` varchar(600) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '密钥\r\n',
  `phoneNumber` varchar(255) NOT NULL COMMENT '手机号',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
BEGIN;
LOCK TABLES `ai`.`test1` WRITE;
DELETE FROM `ai`.`test1`;
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `ai`.`userinfo` WRITE;
DELETE FROM `ai`.`userinfo`;
INSERT INTO `ai`.`userinfo` (`id`,`username`,`Account`,`paswrod`,`creatTime`,`status`,`token`,`phoneNumber`) VALUES (1, '张山', 'admin', '123456', '2023-09-20 03:10:55', '1', '123123', '18226625596'),(2, '李四', 'lisi', '123456', '2023-09-12 03:11:00', '1', '1231234', '17895510596'),(3, '王五', 'wangwu', '123456', '2023-09-07 03:11:04', '1', '123456', '18326014175');
UNLOCK TABLES;
COMMIT;
